﻿-- =========================================================================================================
-- Author:		MICHAEL RITACCO
-- Copyright:	2010 MEKHANO GROUP LLC
-- Version:		10/03/2010 1.0
-- =========================================================================================================
CREATE PROCEDURE [flcr].[api_facility_sel_lov]
@FACILITY_ID INT = NULL
,@ACTIVE_FLG BIT = NULL
,@BUILTIN BIT = NULL
,@FACILITY_TYPE INT = NULL
,@ORG INT = NULL
,@RESOURCE_ID INT = NULL

AS
BEGIN TRY
  
	SELECT	A.[FACILITY_ID]
	  FROM	[FLCR].[FACILITY] A 
     WHERE	A.[FACILITY_ID] = COALESCE(@FACILITY_ID,A.[FACILITY_ID])

END TRY
BEGIN CATCH
	EXEC [flcr].[utl_getDBError];
END CATCH
